package zhongbo.java.air.dictionary.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import zhongbo.java.air.dictionary.model.AirPort;

/**
 * 说明：
 *
 * @author 钟波dellNotebook
 * @since 2025年04月01日 星期二 07:28:13
 */
@Mapper
public interface AirPortMapper extends BaseMapper<AirPort> {

    @Select("select count(*) from air_airport where icao_code = #{icaoCode}")
    int selectCountByIcao(String icaoCode);

    @Select("select count(*) from air_airport where iata_code = #{iataCode}")
    int selectCountByIata(String iataCode);

}
